Create VCR, MCR, and Shooting Involved by District

Step 1: Create Scatter Plot (choose scatter plot visual)

                 a. Details = District Name, Xaxis = Violent Crime Rate, Yaxis = Major Crime Rate, Size = Count of Crimes, Tooltips = Shooting Involved Crimes (remove periods from all names)

                 b. Select formatting, in general X position = 151, Y position = 76, Width = 577, Height = 284

                 




                 c. Xaxis. Color = custom (1E5A8E), text size = 9, font = Constantia, title color = black, text size = 10, font = Constantia

                 d. Yaxis, Color = custom (FCB714), text size 9, font = Constantia, title color = black, text size = 10, font = Constantia   


   

                 e. Data Color = format color, field value, Color Measure

                 f. Category, Color = black, text size = 8, font = Constantia

                g. Color borders on




                h. Title, VCR, MCR and Shooting Involved by District, Color = black, background = light gray, alignment = center, text size = 12, font = Constantia

                i. Border = light gray




                j. Select Analytics (magnifying glass) Create xaxis constant line, value = .1846, Color = custom (1E5A8E)

               k. Select Analytics (magnifying glass) Create yaxis constant line, value = .3012, Color = custom (BD890F) 


   


Step 2: Adjust Averages for color measure and Yaxis contstant. Follow GIF below.




 

Here is a video on creating a scatter plot in Power BI. This may help you get started with creating your own.


Scatter Plot Link